Update Method (Remote Data)

Saves the contents of the copy buffer row to a specified updatable rdoResultset object and discards the copy buffer.

Syntax

object.Update

The object placeholder represents an object expression that evaluates to an object in the Applies To list.

Remarks

Use Update to save the current row and any changes you’ve made to it to the underlying database table(s). Changes you make to the rdoResultset after using the AddNew or Edit methods can be lost if you do not use the Update method before the application ends.

Note   When you use the ClientBatch cursor library, all updates to the base tables are deferred until you use the BatchUpdate method. In this case, the Update method updates the local rdoResultset, but does not update the base tables. These changes can be lost if the application ends before the BatchUpdate method has been completed.

Changes to the current row are lost if:

• You use the Edit or AddNew method, and then reposition the current row pointer to another row without first using Update.
  
  
• You use Edit or AddNew, and then use Edit or AddNew again without first using Update.
  
  
• You cancel the update with the CancelUpdate method.
  
  
• You set the Bookmark property to another row.
  
  
• You close the result set referred to by object without first using Update.
  
  
• The application ends before the Update method is executed, as when system power is interrupted.

To edit a row, use the Edit method to copy the contents of the current row to the copy buffer. If you don’t use AddNew or Edit first, an error occurs when you use Update or attempt to add a new row.

To add a new row, use the AddNew method to initialize and activate the copy buffer.

Using Update produces an error under any of the following conditions:

• There is no current row.
  
  
• The connection or rdoResultset is read-only.
  
  
• No columns in the row are updatable.
  
  
• You do not have an Edit or AddNew operation pending.
  
  
• Another user has locked the row or data page containing your row.
  
  
• The user does not have permission to perform the operation.
  
  
• Depending on the driver and type of cursor being used, you might not be able to use the cursor to update the primary key.